CREATE TABLE IF NOT EXISTS [Album] (
[AlbumID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[BandID] INTEGER NOT NULL,
[Name] NVARCHAR(100) NOT NULL,
[ReleaseYear] INTEGER NOT NULL
);

CREATE TABLE IF NOT EXISTS [Band] (
[BandID] INTEGER  PRIMARY KEY AUTOINCREMENT NOT NULL,
[Name] NVARCHAR(100) NOT NULL
);


